<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ taglib prefix="cms" uri="http://cms.gxsoft.com/tags-cms"%>

<%
response.setHeader("Cache-Control","no-store"); 
response.setHeader("Pragrma","no-cache"); 
response.setDateHeader("Expires",0); 
response.setContentType("application/x-msdownload"); 
response.setHeader("content-disposition","attachment;filename=employerAnnualStatistics.xls"); 
%>

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>liuxj</o:Author>
  <o:LastAuthor>liuxj</o:LastAuthor>
  <o:Created>2009-02-17T10:25:19Z</o:Created>
  <o:LastSaved>2009-02-17T10:32:27Z</o:LastSaved>
  <o:Version>11.5606</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:1.0in .75in 1.0in .75in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl24
	{mso-style-parent:style0;
	font-size:16.0pt;
	font-weight:700;
	text-align:center;}
.xl25
	{mso-style-parent:style0;
	border:.5pt solid windowtext;}
.xl26
	{mso-style-parent:style0;
	font-weight:700;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl27
	{mso-style-parent:style0;
	color:#333333;
	font-weight:700;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl28
	{mso-style-parent:style0;
	font-weight:700;
	border:.5pt solid windowtext;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>300</x:HorizontalResolution>
      <x:VerticalResolution>300</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>3</x:ActiveRow>
       <x:ActiveCol>5</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>8670</x:WindowHeight>
  <x:WindowWidth>10635</x:WindowWidth>
  <x:WindowTopX>480</x:WindowTopX>
  <x:WindowTopY>105</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026"/>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>

<table x:str border=0 cellpadding=0 cellspacing=0 width=656 style='border-collapse:
 collapse;table-layout:fixed;width:493pt'>
 <col width=238 style='mso-width-source:userset;mso-width-alt:7616;width:179pt'>
 <col width=68 style='mso-width-source:userset;mso-width-alt:2176;width:51pt'>
 <col width=72 style='mso-width-source:userset;mso-width-alt:2304;width:54pt'>
 <col width=69 style='mso-width-source:userset;mso-width-alt:2208;width:52pt'>
 <col width=66 style='mso-width-source:userset;mso-width-alt:2112;width:50pt'>
 <col width=71 style='mso-width-source:userset;mso-width-alt:2272;width:53pt'>
 <col width=72 style='width:54pt'>
 <tr height=27 style='height:20.25pt'>
  <td colspan=6 rowspan=2 height=54 class=xl24 width=584 style='height:40.5pt;
  width:439pt'>${param.year}年<cms:query value="${param.areaCode}"></cms:query>未参加年审企业统计表</td>
  <td class=xl24 width=72 style='width:54pt'></td>
 </tr>
 <tr height=27 style='height:20.25pt'>
  <td height=27 class=xl24 style='height:20.25pt'></td>
 </tr>
 <tr height=94 style='mso-height-source:userset;height:70.5pt'>
  <td height=94 class=xl26 width=238 style='height:70.5pt;width:179pt'>企业名称</td>
  <td class=xl26 width=68 style='border-left:none;width:51pt'>企业职工总数</td>
  <td class=xl26 width=72 style='border-left:none;width:54pt'>其中签定合同人数</td>
  <td class=xl27 width=69 style='border-left:none;width:52pt'>签订合同人数占总人数的%</td>
  <td class=xl27 width=66 style='border-left:none;width:50pt'>其中未投保人数</td>
  <td class=xl27 width=71 style='border-left:none;width:53pt'>投保人数占总人数的%</td>
  <td></td>
  <c:forEach items="${list}" var="prod" varStatus="lineInfo">
  <c:set var="empInfoAllWorkNum" scope="page" value="${empInfoAllWorkNum + prod.empInfoAllWorkNum}"/>
  <c:set var="empInfoContractedNum" scope="page" value="${empInfoContractedNum + prod.empInfoContractedNum}"/>
  <c:set var="empInfoNoInsNum" scope="page" value="${empInfoNoInsNum + prod.empInfoNoInsNum}"/>
  </c:forEach>
  <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl28 style='height:22.5pt;border-top:none'>总计</td>
  <td class=xl28 style='border-top:none;border-left:none'>${empInfoAllWorkNum}</td>
  <td class=xl28 style='border-top:none;border-left:none'>${empInfoContractedNum}</td>
  <td class=xl28 style='border-top:none;border-left:none'><c:if test="${empInfoAllWorkNum != '0'}"><fmt:formatNumber value="${empInfoContractedNum/empInfoAllWorkNum*100}" pattern="#.0#"/></c:if></td>
  <td class=xl28 style='border-top:none;border-left:none'>${empInfoNoInsNum}</td>
  <td class=xl28 style='border-top:none;border-left:none'><c:if test="${empInfoAllWorkNum != '0'}"><fmt:formatNumber value="${(empInfoAllWorkNum-empInfoNoInsNum)/empInfoAllWorkNum*100}" pattern="#.0#"/></c:if></td>
  <td></td>
 </tr>

 </tr>
  <c:forEach items="${list}" var="prod" varStatus="lineInfo">
 <tr height=29 style='mso-height-source:userset;height:21.75pt'>
  <td height=29 class=xl25 style='height:21.75pt;border-top:none'>${prod.empInfoName}</td>
  <td class=xl25 style='border-top:none;border-left:none'>${prod.empInfoAllWorkNum}</td>
  <td class=xl25 style='border-top:none;border-left:none'>${prod.empInfoContractedNum}</td>
  <td class=xl25 style='border-top:none;border-left:none'><c:if test="${prod.empInfoAllWorkNum != '0'}"><fmt:formatNumber value="${prod.empInfoContractedNum/prod.empInfoAllWorkNum*100}" pattern="#.0#"/></c:if></td>
  <td class=xl25 style='border-top:none;border-left:none'>${prod.empInfoNoInsNum}</td>
  <td class=xl25 style='border-top:none;border-left:none'><c:if test="${prod.empInfoAllWorkNum != '0'}"><fmt:formatNumber value="${(prod.empInfoAllWorkNum-prod.empInfoNoInsNum)/prod.empInfoAllWorkNum*100}" pattern="#.0#"/></c:if></td>
  <td></td>
 </tr>
 </c:forEach>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=238 style='width:179pt'></td>
  <td width=68 style='width:51pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=69 style='width:52pt'></td>
  <td width=66 style='width:50pt'></td>
  <td width=71 style='width:53pt'></td>
  <td width=72 style='width:54pt'></td>
 </tr>
 <![endif]>
</table>

</body>

</html>
